CREATE TABLE [dbo].[JOL_Lecture]
(
[JOL_Lecture_No] [int] NOT NULL IDENTITY(1, 1),
[JOL_Lecture_Purpose] [int] NULL,
[JOL_Lecture_Title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Lecture_Linkman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Lecture_Mobile] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Lecture_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Lecture_Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Lecture_Fax] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Lecture_ClickNumber] [int] NULL,
[JOL_Lecture_Body] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Lecture_IsSetTop] [bit] NULL CONSTRAINT [DF__JOL_Lectu__JOL_L__21F5FC7F] DEFAULT ((0)),
[JOL_Lecture_RequireNumber] [int] NULL,
[JOL_Lecture_RequireStudyLevel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Lecture_AddTime] [datetime] NULL,
[JOL_Lecture_AddUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Lecture_UpdateTime] [datetime] NULL,
[JOL_Lecture_UpdateUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Lecture_VerifyStatus] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Lectu__JOL_L__22EA20B8] DEFAULT ('未审核'),
[JOL_Lecture_VerifyUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Lecture_VerifyTime] [datetime] NULL,
[JOL_Lecture_IsSendEmail] [bit] NULL CONSTRAINT [DF__JOL_Lectu__JOL_L__23DE44F1] DEFAULT ((1))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Lecture] ADD CONSTRAINT [PK__JOL_Lecture__2101D846] PRIMARY KEY CLUSTERED  ([JOL_Lecture_No]) ON [PRIMARY]
GO
